﻿<?xml version="1.0" encoding="utf-8" ?>
<document >
  <sheetlimit  />
  <paging columnindex="0" regex=".*井钻井取心描述记录" />
  <schemes>
    <scheme>
      <targetname>dr_pg_coring_description</targetname>
      <rules>
        <rule>
          <location columnindex="0" rowindex="0"/>
          <evaluation>
            <simplevalue>
              <regex>(.*)井钻井取心描述记录</regex>
              <mapreduce>
                <target groupindex="1" property="well_common_name" type="string"/>
              </mapreduce>
            </simplevalue>
          </evaluation>
        </rule>
        <rule>
          <location columnindex="0" rowindex="2"/>
          <evaluation>
            <simplevalue>
              <regex>第 *(\d+) *筒 *取心井段：(.*)～(.*)m.*进尺：(.*)m.*岩心长： (.*)m，　收获率： (.*)%，　层位：(.*)。</regex>
              <mapreduce>
                <target groupindex="1" property="coring_no" type="string" />
                <target groupindex="2" property="md_top" type="float" defaultvalue="0.0"/>
                <target groupindex="3" property="md_base" type="float" defaultvalue="0.0"/>
                <target groupindex="4" property="core_length" type="float" defaultvalue="0.0"/>
                <target groupindex="6" property="zone_name" type="string" defaultvalue="0.0"/>
              </mapreduce>
            </simplevalue>
          </evaluation>
        </rule>
        <rule>
          <location columnindex="0" rowindex="3"/>
          <evaluation>
            <simplevalue>
              <regex>含油气情况：饱含油：(.*)m，富含油：(.*)m，油浸：(.*)m，含水油浸：(.*)m，油斑：(.*)m，含水油斑：(.*)m，</regex>
              <mapreduce>
                <target groupindex="1" property="oil_sat_core_length" type="float" />
                <target groupindex="2" property="oil_ful_core_length" type="float" defaultvalue="0.0"/>
                <target groupindex="3" property="oil_immersion_core_length" type="float" defaultvalue="0.0"/>
                <target groupindex="3" property="hsyj" type="float" defaultvalue="0.0"/>
                <target groupindex="4" property="oil_patch_core_length" type="float" defaultvalue="0.0"/>
                <target groupindex="5" property="hsyb" type="float" defaultvalue="0.0"/>
              </mapreduce>
            </simplevalue>
          </evaluation>
        </rule>
        <rule>
          <location columnindex="0" rowindex="3"/>
          <evaluation>
            <simplevalue>
              <regex>油迹：      m，含水油迹：      m，含气： 0.99 m，含水含气：      m，累计含油气岩心长度： 0.99 m。</regex>
              <mapreduce>
                <target groupindex="1" property="oil_trace_core_length" type="float" />
                <target groupindex="2" property="hsyj" type="float" defaultvalue="0.0"/>
                <target groupindex="3" property="hq" type="float" defaultvalue="0.0"/>
                <target groupindex="3" property="hshq" type="float" defaultvalue="0.0"/>
                <target groupindex="4" property="ljhy" type="float" defaultvalue="0.0"/>
              </mapreduce>
            </simplevalue>
          </evaluation>
        </rule>
        <rule>
          <location columnindex="9" startrow="7"/>
          <evaluation>
            <complexvalue>
              <targetname>litho_petro_desc</targetname>
              <reference columnindex="0" regex=".*"/>
              <reduce>
                <regex>(?!.*审核人)^.*$</regex>
                <mapreduce>
                  <target type="string"  groupindex="0" property="mac"/>
                </mapreduce>
              </reduce>
            </complexvalue>
          </evaluation>
        </rule>
      </rules>
    </scheme>
    <scheme>
      <targetname>dr_pg_coring_desc_data</targetname>
      <rules>
        <rule>
          <location columnindex="0" rowindex="0"/>
          <evaluation>
            <simplevalue>
              <regex>(.*)井钻井取心描述记录</regex>
              <mapreduce>
                <target groupindex="1" property="well_common_name" type="string" cannull="false"/>
              </mapreduce>
            </simplevalue>
          </evaluation>
        </rule>
        <rule>
          <location columnindex="0" startrow="7"/>
          <evaluation>
            <simplevalue>
              <regex>(?!.*描述人)^.*$</regex>
              <mapreduce>
                <target groupindex="0" property="coring_no" type="int" cannull="false"/>
              </mapreduce>
            </simplevalue>
          </evaluation>
        </rule>
        <rule>
          <location columnindex="1" startrow="7"/>
          <evaluation>
            <simplevalue>
              <regex>.*</regex>
              <mapreduce>
                <target groupindex="0" property="coring_seq" type="int" cannull="false"/>
              </mapreduce>
            </simplevalue>
          </evaluation>
        </rule>
        <rule>
          <location columnindex="2" startrow="7"/>
          <evaluation>
            <simplevalue>
              <regex>.*</regex>
              <mapreduce>
                <target groupindex="0" property="wear_situation" type="string" cannull="true"/>
              </mapreduce>
            </simplevalue>
          </evaluation>
        </rule>
        <rule>
          <location columnindex="3" startrow="7"/>
          <evaluation>
            <simplevalue>
              <regex>.*</regex>
              <mapreduce>
                <target groupindex="0" property="section_length" type="float" cannull="false"/>
              </mapreduce>
            </simplevalue>
          </evaluation>
        </rule>
        <rule>
          <location columnindex="4" startrow="7"/>
          <evaluation>
            <simplevalue>
              <regex>.*</regex>
              <mapreduce>
                <target groupindex="0" property="cum_length" type="float" cannull="false"/>
              </mapreduce>
            </simplevalue>
          </evaluation>
        </rule>
        <rule>
          <location columnindex="5" startrow="7"/>
          <evaluation>
            <simplevalue>
              <regex>.*</regex>
              <mapreduce>
                <target groupindex="0" property="md_base" type="float" cannull="true"/>
              </mapreduce>
            </simplevalue>
          </evaluation>
        </rule>
        <rule>
          <location columnindex="6" startrow="7"/>
          <evaluation>
            <simplevalue>
              <regex>.*</regex>
              <mapreduce>
                <target groupindex="0" property="sample_seq" type="float" cannull="true"/>
              </mapreduce>
            </simplevalue>
          </evaluation>
        </rule>
        <rule>
          <location columnindex="7" startrow="7"/>
          <evaluation>
            <simplevalue>
              <regex>.*</regex>
              <mapreduce>
                <target groupindex="0" property="sample_seq_sample_top_location" type="float" cannull="true"/>
              </mapreduce>
            </simplevalue>
          </evaluation>
        </rule>
        <rule>
          <location columnindex="8" startrow="7"/>
          <evaluation>
            <simplevalue>
              <regex>.*</regex>
              <mapreduce>
                <target groupindex="0" property="ligto_name" type="float" cannull="true"/>
              </mapreduce>
            </simplevalue>
          </evaluation>
        </rule>
        <rule>
          <location columnindex="9" startrow="7"/>
          <evaluation>
            <simplevalue>
              <regex>(?!.*审核人)^.*$</regex>
              <mapreduce>
                <target groupindex="0" property="litho_petro_desc" type="string" cannull="false"/>
              </mapreduce>
            </simplevalue>
          </evaluation>
        </rule>
        <rule>
          <location columnindex="10" startrow="7"/>
          <evaluation>
            <simplevalue>
              <regex>.*</regex>
              <mapreduce>
                <target groupindex="0" property="fluore_area" type="string" cannull="true"/>
              </mapreduce>
            </simplevalue>
          </evaluation>
        </rule>
        <rule>
          <location columnindex="11" startrow="7"/>
          <evaluation>
            <simplevalue>
              <regex></regex>
              <mapreduce>
                <target groupindex="0" property="fluore_color" type="string" cannull="true"/>
              </mapreduce>
            </simplevalue>
          </evaluation>
        </rule>
        <rule>
          <location columnindex="12" startrow="7"/>
          <evaluation>
            <simplevalue>
              <regex>.*</regex>
              <mapreduce>
                <target groupindex="0" property="fluore_series_level" type="string" cannull="true"/>
              </mapreduce>
            </simplevalue>
          </evaluation>
        </rule>
        <rule>
          <location columnindex="13" startrow="7"/>
          <evaluation>
            <simplevalue>
              <regex>.*</regex>
              <mapreduce>
                <target groupindex="0" property="fluore_quantitative" type="string" cannull="true"/>
              </mapreduce>
            </simplevalue>
          </evaluation>
        </rule>
        <rule>
          <location columnindex="14" startrow="7"/>
          <evaluation>
            <simplevalue>
              <regex>.*</regex>
              <mapreduce>
                <target groupindex="0" property="s_t" type="string" cannull="true"/>
              </mapreduce>
            </simplevalue>
          </evaluation>
        </rule>
      </rules>
    </scheme>
  </schemes>
</document>